﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using VeMayBayDTO;
namespace VeMayBayDAO
{
   public  class ThamSoDAO
    {

       public static ThamSoDTO GetAllThamSo()
       {
           ThamSoDTO ts = new ThamSoDTO();
           string query = "select * from thamso";
           DataTable dt = new DataTable();
           dt = DataProvider.ExecQuery(query);
           if (dt.Rows.Count > 0)
           {
               ts.ThoiGianBayToiThieu = (int)dt.Rows[0]["thoigianbaytoithieu"];
               ts.SoSanBayTGToiDa = (int)dt.Rows[0]["sosanbaytgtoida"];
               ts.ThoiGianDungToiDa = (int)dt.Rows[0]["thoigiandungtoida"];
               ts.ThoiGianDungToiThieu = (int)dt.Rows[0]["thoigiandungtoithieu"];
               ts.ThoiGianHuyVe = (int)dt.Rows[0]["thoigianhuyve"];
           }
           return ts;
       }
       public static int GetTimeFlayMin()
       {
           return 1;//
       }
       public static bool UpdateTimeFlayMin(string time)
       {
           return true;
       }
       public static int GetNumAirportMax()
       {
           return 1;//
       }
       public static bool UpdateNumAirportMax(string num)
       {
           return true;
       }
       public static int GetTimeStopMin()
       {
           return 1;
       }
       public static bool UpdateTimeStopMin()
       {
           return true;
       }
       public static int GetTimeStopMax()
       {
           return 1;
       }
       public static bool UpdateTimeStopMax()
       {
           return true;
       }
       public static int GetTimeDatVeMin()
       {
           return 1;//
       }
       public static bool UpdateTDatveMin(string num)//Truoc May ngay
       {
           return true;
       }
       public static int GetTimeDatVeMax()
       {
           return 1;//
       }
       public static bool UpdateTDatveMax(string num)//Truoc May ngay
       {
           return true;
       }

    }
}
